Oracle Applications JumpStart Guide

This guide is designed to get you a basic Oracle Applications connection that is useful without going through the different parts of the documentation. At the end of this walk through you will find links to relevant topics for each step, should you wish to customize the setup.

Prerequisites

  • JDBC connection string to the Oracle database of the Oracle Applications system
  • Database user with privileges to start ADS Current Vacancy Details (PER_ADSCURVACDET).

Process Flow

  1. Create JDBC Credential
  2. Create Database Connection
  3. Create Oracle Applications System
  4. Import Concurrent Program
  5. Schedule Imported Concurrent Program

Create JDBC Credential

  1. Navigate to Security > Credentials.
  2. Choose New Credential from the context menu.
  3. Choose JDBCProtocol.
  4. Fill the database username into the Real User.
  5. Fill the password and confirm the password in the Password and Retype.
  6. Fill the database name server into the Endpoint field.

Create Database Connection

  1. Navigate to Environment > Database.
  2. Choose New Database from the context menu.
  3. Fill the database name server into the Name field; it must match your credential Endpoint field.
  4. Select Oracle Thin in Connection > Jdbc Driver Class Name field.
  5. Fill the database server hostname (ideally FQDN name) into the Host field, the Port field is optional, fill this when the port number is not 1521, fill the database service name into the Database field.
  6. Select the previously created credential in the Connection User field and choose Test Connection, a message Successfully connected to <database_url> using <jdbc_driver_class> is displayed.

Create Oracle Applications System

  1. Navigate to Environment > Oracle Applications.
  2. Choose New Oracle Applications system from the context menu.
  3. Fill a name into the Name field, select the previously created Oracle database connection in the Database field.
  4. Select a time zone for the database, if in doubt, use the time zone of the physical location of the database.
  5. Choose Output Retrieval > Retrieve files using HTTP(S).
  6. Click Save & Close.

Import a Concurrent Program

  1. Navigate to Definitions > Processes.
  2. Fill System_OraApps in the Search field and choose the magnifying glass.
  3. Choose Submit from the context menu of System_OraApps_ConcurrentProgramImport.
  4. Select your Oracle Applications system in the Applications System name field, fill Human and select Human Resources in the Application Short name field, fill ADS and select ADS Current Vacancy Details in the Concurrent Program name field.
  5. Choose Submit and Submit.
  6. Choose Monitor related processes from the context menu of System_OraApps_ConcurrentProgramImport and ensure the import process reaches status Completed.
  7. Expand Files, open stdout.log, notice the name of the imported definition is PER_ADSCURVACDET.

Schedule Imported Concurrent Program

  1. Navigate to Definitions > Processes, search for PER_ADSCURVACDET.
  2. Choose Submit from the context menu of PER_ADSCURVACDET.
  3. Select your Oracle Applications system in the Applications System name field, select your user name, select HRMS Progress UK Super User.
  4. Choose the Layout tab, select Current Vacancy Details in the Layout Code field, select EXCEL in the Format field.
  5. Choose Submit and Submit.
  6. Choose Monitor related processes from the context menu of PER_ADSCURVACDET. Once the process has reached status Completed, expand Files, and open oraAppsTemplate.out.

Further Reading